Skip to content

Use the Holt Winters algorithm to filter time series data

ts_smooth_simple(x, y): The x parameter specifies the time sequence. Points in time are sorted in ascending order. Each point in time is a UNIX timestamp. Unit: seconds. The y parameter specifies the sequence of numeric data at a specific point in time.

SQL
* | select ts_smooth_simple(__time__, status)